SELECT * FROM london_stages WHERE eventid IN (28662, 28664, 28669, 28675, 28679, 28696, 28702, 28707, 28712, 28717, 28726, 28731, 28754, 28782, 28790, 28794, 28800, 28810, 28813, 28815, 28818, 28820, 28839, 28841, 28849, 28854, 28861, 28871, 28882, 28885, 28887, 28896, 28930, 28942, 28956, 28958, 28978, 28997, 29009, 29014, 29046, 29068, 29195, 29203, 29213, 29217, 29244, 29280, 29291, 29300, 29308, 29312, 29315, 29320, 29331, 29336, 29338, 29342, 29344, 29349, 29352, 29357, 29361, 29363, 29367, 29369, 29393, 29395, 29398, 29412, 29424, 29428, 29431, 29442, 29445, 29449, 29452, 29484, 29488, 29496, 29499, 29503, 29532, 29537, 29549, 29583, 29722, 29766, 29810, 29823, 29826, 29877, 29886, 29888, 29890, 29892, 29894, 29899, 29901, 29903, 29907, 29909, 29912, 29914, 29927, 29929, 29958, 29960, 29981, 30006, 30009, 30028, 30039, 30055, 30057, 30081, 30114, 30116, 30145, 30151, 30307, 30309, 30311, 30315, 30321, 30323, 30329, 30337, 30381, 30385, 30388, 30390, 30395, 30408, 30410, 30413, 30415, 30420, 30429, 30432, 30450, 30452, 30475, 30479, 30484, 30566, 30575, 30622, 30653, 30660, 30686, 30690, 30695, 30699, 30785, 30787, 30793, 30801, 30808, 30814, 30852, 30865, 30867, 30870, 30874, 30878, 30880, 30882, 30884, 30886, 30888, 30893, 30900, 30916, 30922, 30924, 30926, 30928, 30930, 30933, 30935, 30937, 30940, 30942, 30944, 30947, 30950, 30954, 30966, 30973, 30979, 30983, 30985, 30987, 30989, 30991, 30993, 30995, 30998, 31001, 31003, 31005, 31007, 31012, 31015, 31017, 31019, 31021, 31023, 31026, 31028, 31031, 31033, 31035, 31037, 31040, 31043, 31049, 31052, 31057, 31061, 31066, 31069, 31074, 31076, 31094, 31097, 31100, 31102, 31109, 31112, 31116, 31136, 31158, 31179, 31182, 31189, 31197, 31203, 31216, 31220, 31223, 31253, 31274, 31339, 31368, 31370, 31372, 31374, 31378, 31380, 31382, 31384, 31387, 31389, 31391, 31393, 31395, 31397, 31399, 31405, 31409, 31411, 31417, 31419, 31426, 31428, 31430, 31432, 31435, 31437, 31439, 31441, 31443, 31445, 31448, 31451, 31453, 31455, 31457, 31459, 31462, 31465, 31467, 31470, 31472, 31474, 31477, 31480, 31484, 31491, 31494, 31496, 31500, 31502, 31504, 31506, 31510, 31513, 31515, 31517, 31519, 31523, 31526, 31531, 31533, 31535, 31537, 31542, 31556, 31569, 31605, 31611, 31614, 31617, 31620, 31626, 31629, 31632, 31636, 31642, 31648, 31657, 31671, 31673, 31686, 31689, 31700, 31703, 31715, 31718, 31725, 31731, 31740, 31747, 31753, 31761, 31767, 31771, 31773, 32319, 32321, 32325, 32329, 32334, 32339, 32342, 32346, 32348, 32350, 32352, 32356, 32358, 32364, 32366, 32382, 32384, 32390, 32393, 32395, 32403, 32407, 32411, 32414, 32437, 32442, 32450, 32452, 32454, 32459, 32464, 32466, 32493, 32523, 32526, 32546, 32558, 32644, 32653, 32666, 32671, 32676, 32678, 32680, 32693, 32704, 32708, 32720, 32722, 32724, 32729, 32734, 32748, 32807, 32813, 32815, 32817, 32822, 32827, 32830, 32832, 32834, 32836, 32838, 32840, 32842, 32846, 32848, 32850, 32852, 32854, 32856, 32858, 32860, 32862, 32864, 32866, 32868, 32870, 32872, 32874, 32876, 32878, 32882, 32884, 32886, 32888, 32890, 32892, 32894, 32898, 32903, 32906, 32908, 32910, 32913, 32915, 32917, 32920, 32922, 32924, 32930, 32933, 32935, 32944, 32949, 32953, 32956, 32958, 32960, 32962, 32966, 32969, 32972, 32974, 32976, 32978, 32981, 32983, 32985, 32987, 32989, 32991, 32994, 32996, 32999, 33003, 33005, 33008, 33010, 33012, 33017, 33020, 33022, 33024, 33026, 33029, 33031, 33034, 33039, 33042, 33045, 33092, 33103, 33106, 33108, 33110, 33116, 33121, 33134, 33136, 33145, 33150, 33158, 33166, 33172, 33179, 33183, 33193, 33195, 33260, 33265, 33267, 33269, 33271, 33273, 33275, 33277, 33285, 33287, 33289, 33291, 33295, 33297, 33300, 33304, 33344, 33346, 33348, 33353, 33362, 33364, 33369, 33372, 33374, 33378, 33381, 33383, 33386, 33390, 33402, 33428, 33441, 33443, 33446, 33448, 33451, 33453, 33455, 33457, 33460, 33462, 33465, 33467, 33471, 33474, 33476, 33479, 33486, 33489, 33491, 33494, 33496, 33498, 33501, 33510, 33517, 33524, 33526, 33529, 33531, 33538, 33563, 33570, 33572, 33585, 33589, 33604, 33617, 33620, 33622, 33626, 33647, 33659, 33664, 33673, 33693, 33700, 33710, 33719, 33725, 33792, 33798, 33800, 33802, 33804, 33806, 33808, 33810, 33814, 33819, 33821, 33823, 33825, 33829, 33831, 33833, 33837, 33839, 33841, 33843, 33849, 33875, 33882, 33889, 33898, 33903, 33905, 33907, 33917, 33919, 33921, 33924, 33929, 33933, 33962, 33969, 33972, 34014, 34017, 34040, 34050, 34058, 34063, 34069, 34072, 34078, 34146, 34161, 34173, 34182, 34187, 34197, 34202, 34204, 34237, 34258, 34317, 34342, 34350, 34374, 34397, 34400, 34406, 34410, 34418, 34578, 34580, 34681, 34688, 34696, 34722, 34770, 34772, 34779, 34893, 34901, 34905, 34913, 34984, 34989, 35033, 35062, 35064, 35068, 35080, 35083, 35085, 35090, 35097, 35102, 35104, 35106, 35113, 35120, 35132, 35138, 35147, 35195, 35210, 35240, 35245, 35250, 35274, 35286, 35302, 35321, 35332, 35337, 35354, 35357, 35379, 35381, 35495, 35498, 35566, 35573, 35577, 35581, 35587, 35595, 35603, 35617, 35621, 35626, 35629, 35635, 35642, 35645, 35647, 35650, 35653, 35656, 35659, 35662, 35665, 35667, 35669, 35672, 35674, 35676, 35678, 35681, 35683, 35686, 35688, 35693, 35696, 35702, 35707, 35716, 35718, 35723, 35756, 35761, 35788, 35802, 35810, 35813, 35818, 35823, 35826, 35865, 35868, 35918, 35986, 35989, 35992, 36113, 36201, 36219, 36223, 36225, 36232, 36237, 36239, 36243, 36253, 36257, 36262, 36264, 36266, 36269, 36273, 36275, 36279, 36282, 36284, 36289, 36291, 36296, 36301, 36305, 36308, 36317, 36336, 36343, 36345, 36352, 36355, 36357, 36367, 36381, 36409, 36437, 36473, 36482, 36499, 36504, 36508, 36516, 36540, 36546, 36555, 36565, 36636, 36649, 36651, 36653, 36673, 36688, 36696, 36704, 36710, 36714, 36717, 36738, 36750, 36752, 36756, 36764, 36773, 36784, 36795, 36798, 36800, 36802, 36804, 36806, 36808, 36811, 36813, 36816, 36818, 36820, 36822, 36825, 36827, 36830, 36832, 36834, 36837, 36839, 36844, 36846, 36850, 36853, 36855, 36860, 36878, 36881, 36883, 36890, 36897, 36902, 36904, 36906, 36914, 36925, 36955, 36957, 37028, 37044, 37080, 37094, 37119, 37124, 37212, 37216, 37233, 37235, 37237, 37239, 37243, 37245, 37247, 37253, 37257, 37264, 37270, 37272, 37276, 37307, 37317, 37319, 37321, 37324, 37326, 37329, 37333, 37335, 37340, 37343, 37347, 37354, 37359, 37371, 37378, 37380, 37382, 37384, 37388, 37393, 37398, 37402, 37407, 37414, 37419, 37424, 37430, 37436, 37439, 37443, 37445, 37455, 37460, 37467, 37477, 37479, 37517, 37524, 37566, 37570, 37579, 37584, 37602, 37618, 37637, 37643, 37646, 37665, 37667, 37671, 37675, 37785, 37790, 37795, 37807, 37813, 37815, 37819, 37821, 37825, 37827, 37829, 37833, 37835, 37837, 37852, 37856, 37870, 37874, 37887, 37893, 37897, 37902, 37905, 37907, 37916, 37925, 37941, 37943, 37949, 37962, 38050, 38060, 38123, 38153, 38156, 38158, 38167, 38172, 38177, 38183, 38216, 38219, 38224, 38315, 38320, 38330, 38334, 38336, 38341, 38367, 38422, 38434, 38439, 38448, 38450, 38453, 38455, 38457, 38464, 38467, 38469, 38471, 38561, 38573, 38583, 38598, 38611, 38658, 38675, 38682, 38700, 38719, 38731, 38743, 38760, 43645, 43660, 43675, 43690, 43733, 43748, 43864, 44329, 45100, 45105) GROUP BY eventid ORDER BY eventdate ASC OPTION

Result Options

Download:
JSON XML CSV

Search Filters

Event

Date Range
Start
End

Performance

?
Filter by Performance Type










Cast

?

Keyword

?

Performances

Mainpiece Title: The Tempest

Afterpiece Title: The Author

Performances

Mainpiece Title: The Tempest

Afterpiece Title: The Author

Performances

Mainpiece Title: The Tempest

Afterpiece Title: The Apprentice

Performances

Mainpiece Title: The Busy Body

Performances

Mainpiece Title: The Tempest

Afterpiece Title: Harlequin Ranger

Performances

Mainpiece Title: The Tempest

Afterpiece Title: Harlequin Ranger

Performances

Mainpiece Title: The Tempest

Afterpiece Title: Harlequin Ranger

Performances

Mainpiece Title: The Tempest

Afterpiece Title: Harlequin Ranger

Performances

Mainpiece Title: The Tempest

Afterpiece Title: Lethe

Performances

Mainpiece Title: The Tempest

Afterpiece Title: Harlequin Ranger

Performances

Mainpiece Title: The Tempest

Afterpiece Title: Harlequin Ranger

Performances

Mainpiece Title: The Tempest

Afterpiece Title: The Male Coquette

Performances

Mainpiece Title: The Tempest

Afterpiece Title: Harlequin Ranger

Dance: I: The Market, as17571126

Performances

Mainpiece Title: The Gamesters

Ballet: New Comic Entertainment of Dancing, call'dThe Prussian Camp. Officer-Blakes; Prussian Soldiers-the Comedians; Characters of the Dance-Delatre, Giorgi, Lucchi, Mrs Vernon. New Habits and Decorations for the Dance

Performances

Mainpiece Title: The Tempest

Afterpiece Title: Harlequin Ranger

Performances

Mainpiece Title: The Busy Body

Afterpiece Title: Harlequin Ranger

Ballet: II: The Prussian Camp. As17571223

Performances

Mainpiece Title: The Gamesters

Ballet: End: The Prussian Camp. As17571223

Performances

Mainpiece Title: The Gamesters

Dance: II: The Italian Peasants, as17571004

Ballet: End: The Prussian Camp. As17571223

Performances

Mainpiece Title: The Mourning Bride

Afterpiece Title: The Author

Performances

Mainpiece Title: Zara

Performances

Mainpiece Title: The Gamesters

Afterpiece Title: The Male Coquette

Performances

Mainpiece Title: The Gamesters

Afterpiece Title: The Author

Ballet: TThe Prussian Camp. As17571223, but Officer-_

Performances

Mainpiece Title: The Tempest

Afterpiece Title: Queen Mab

Performances

Mainpiece Title: The Wonder

Afterpiece Title: The Chaplet